Line and clustered column Visual 15
Visual 1: Line and clustered column Visual >>
Deaths Per Mth, %MoM, %/YoY by Month
For gif Step1
Fields
Tab
·
Shared Axis: Month/Year/Quarter
·
Column Values: Deaths Per Mth
·
Line Values: %MoM, %YoY
Format
Tab
·
General: X Position = 231, Y Position = 91,
Width = 515, Height 310
·
·
Legend: On, Position =
Top, Title = off, Color = #00000, font
family = Segoe UI, Text size = 10, Style = Markers Only, Match line color = on,
Circle default icon = on
·
X Axis: Color = #00000, Text Size
= 9, Font family = Segoe UI, Minimum category width = 20, Maximum Size = 25%,
Inner Padding = 15%,
Concatenate labels = On, Title = off
·
Y Axis: Position = Left,
Scale Type = Linear, start = Auto, End = Auto, Invert axis= off, Color = #00000, Text size
= 10, Font family =
Segoe UI, Display Units = Auto, Value decimal Places= Auto, Title = off, Gridlines =
on, Line color = #CCCCC,
Strock width = 2, Line Style = Dotted, show secondary = On, Align zeros = on
·
Zoom Slider
= off,
·
Data Colors,
%MoM = #33DBFF, YoY% = #ECC846, Default Color = #00000,
Show all = off
· Data Label = On, Color = #FFFFF, Display Units = Auto, Value Decimal places = Auto, Orientation = Horizontal, Position = Auto, Text Size = 10, Font Family = DIN, Show Background = On, Background Color = #FFFFFF, Transparency = 100%, Customize series = off
·
Shapes: Shade area = On, Stroke
width = 2, Join
Type = Round, Line Style = Solid, show marker = on, Marker shape =., Meaker Size = 5, Marker color = #FFFFF, stepped
= off, customize series = on, %MoM, Shade area = on, Stroke width = 2, Join type
= round, Line style = Solid, show
marker = on, Marker size = 5, Marker color = #ECC846, Stepped = off
·
Plot area Transparency
= 0%
For gif Step 3
·
Title = On, Title Text
= By Month, Title heading = Heading 3, Word wrap = On, font color = #FFFFF, Background color = #00000, Alignment
= Center, Text Size
= 14, Font Family = Segoe UI
·
Background:
On, color = #FFFFF, Transparency = 0
·
Lock aspect
= off
·
Border: = off
·
Shadow: = off
·
Tooltip = On, Type =
Report Page, Page = Auto, Label Text color = #C8C8C8, Value text color =
#EAEAEA, Text size = 9, Font family = Segoe UI, Background color = #00000, Transparency = 5%
·
Visual header
= On, background color = #FFFFFF, Boarder = #FFFFFF, Transparency = 0%, Icon color = #00000,
Visual information icon = On, Visual warning icon = On, Visual error icon = on,
Drill on drop down = On, drill up icon = On, Drill down icon = On, show next
level icon = On, Expand to next level icon = On, Pin icon = On, Focus mode icon
= On, Filter icon = On, See data layout icon = On, More Options icon = On,
Visua headre tooltip icon = off
Use the following step
by step Gif to create the visual
Step 1
Step 2
Step 3
How to create line and clustered column chart in power bi
https://www.youtube.com/watch?v=2d1JhcrhhGo